﻿CREATE TABLE [Core].[File] (
    [FileId]         UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [DomainId]       UNIQUEIDENTIFIER NOT NULL,
    [BusinessUnitId] UNIQUEIDENTIFIER NOT NULL,
    [Description]    NVARCHAR (127)   NOT NULL,
    [Filename]       NVARCHAR (127)   NOT NULL,
    [Extension]      NVARCHAR (10)    NOT NULL,
    [Size]           INT              NOT NULL,
    [Data]           VARBINARY (MAX)  NOT NULL,
    [IsPublicYN]     NCHAR (1)        NOT NULL,
    [CreateDT]       DATETIME         NOT NULL,
    [CreatedById]    UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]  NVARCHAR (127)   NOT NULL,
    [LastAccessedDT] DATETIME         NOT NULL
);

